﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 第三方登录信息管理实体类：fanli_userInfoFromApi 。
	/// </summary>
	[Serializable]
	public class fanli_userInfoFromApi
	{
		public fanli_userInfoFromApi()
		{}

		#region Model
		private int _id; //id
		private string _apiName; //第三方名称
		private string _apiUsername; //第三方标识
		private DateTime? _loginDate; //登录时间
		private int _userid; //用户id
		private string _ext1; //扩展1
		private string _ext2; //扩展2
		private string _ext3; //扩展3
		private string _ext4; //扩展4


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 第三方名称
		/// </summary>
		public string apiName
		{
			set{ _apiName=value;}
			get{return _apiName;}
		}
        /// <summary>
		/// 第三方标识
		/// </summary>
		public string apiUsername
		{
			set{ _apiUsername=value;}
			get{return _apiUsername;}
		}
        /// <summary>
		/// 登录时间
		/// </summary>
		public DateTime? loginDate
		{
			set{ _loginDate=value;}
			get{return _loginDate;}
		}
        /// <summary>
		/// 用户id
		/// </summary>
		public int userid
		{
			set{ _userid=value;}
			get{return _userid;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
        /// <summary>
		/// 扩展3
		/// </summary>
		public string ext3
		{
			set{ _ext3=value;}
			get{return _ext3;}
		}
        /// <summary>
		/// 扩展4
		/// </summary>
		public string ext4
		{
			set{ _ext4=value;}
			get{return _ext4;}
		}
		#endregion Model

		#region txt document
		/*
第三方登录信息管理,userInfoFromApi
id,第三方名称,第三方标识,登录时间,用户id,扩展1,扩展2,扩展3,扩展4
id,apiName,apiUsername,loginDate,userid,ext1,ext2,ext3,ext4
i,c40,c100,d,i,c100,c100,c100,c100


--------------------------
-- 创建表[第三方登录信息管理]开始: 
-- alter table  [fanli_userInfoFromApi] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_userInfoFromApi') drop table fanli_userInfoFromApi
  CREATE TABLE [fanli_userInfoFromApi] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [apiName] [varchar] (40),
	 [apiUsername] [varchar] (100),
	 [loginDate] [datetime],
	 [userid] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100),
	 [ext3] [varchar] (100),
	 [ext4] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'第三方登录信息管理 ',N'user',N'dbo',N'table',N'fanli_userInfoFromApi', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'第三方名称',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'apiName'
 exec sp_addextendedproperty N'MS_Description',N'第三方标识',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'apiUsername'
 exec sp_addextendedproperty N'MS_Description',N'登录时间',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'loginDate'
 exec sp_addextendedproperty N'MS_Description',N'用户id',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'userid'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'ext2'
 exec sp_addextendedproperty N'MS_Description',N'扩展3',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'ext3'
 exec sp_addextendedproperty N'MS_Description',N'扩展4',N'user',N'dbo',N'table',N'fanli_userInfoFromApi',N'column',N'ext4'

-- 创建表[第三方登录信息管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

